create external table jms_dwd.dwd_tab_platform_order_info_hi
(
WAYBILL_ID        string    comment  '运单id'
,ORDER_SOURCE_NAME string    comment  '订单来源名称'
,ORDER_SOURCE_CODE string    comment  '订单来源code'
,INPUT_TIME        date      comment  '订单录入时间'
,PICK_END_TIME     date      comment  '订单揽收截止时间'
,CREATED           date      comment  '创建时间'
)PARTITIONED BY (
   `dt` string COMMENT '更新/创建日期 (yyyy-MM-dd--hh)')
comment'线下订单表dwd'
stored as parquet
location '/dw/hive/jms_dwd.db/external/dwd_tab_platform_order_info_hi'
tblproperties (
'discover.partitions' = 'false',
'parquet.column.index.access' = 'true'
);


